package cn.may.easyexcel;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.format.DateTimeFormat;
import com.alibaba.excel.annotation.write.style.ColumnWidth;
import com.alibaba.excel.annotation.write.style.HeadFontStyle;
import com.alibaba.excel.annotation.write.style.HeadStyle;
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import lombok.Data;
import org.apache.poi.ss.usermodel.FillPatternType;

/**
 * @author May
 * @date 2020/10/29 13:37
 * @desc
 */
@Data
@HeadStyle(fillPatternType = FillPatternType.SOLID_FOREGROUND, fillForegroundColor = 22)
@HeadFontStyle(fontHeightInPoints = 12)
public class UserData {
    @ExcelProperty("编号")
    private String id;
    @ColumnWidth(10)
    @ExcelProperty("姓名")
    private String name;
    @ExcelProperty("年龄")
    private Integer age;
    @ExcelProperty("性别")
    private String sex;
    @ExcelProperty("生日")
    @ColumnWidth(15)
    @DateTimeFormat("yyyy-MM-dd")
    private String date;
    @ExcelProperty("存款")
    @ColumnWidth(15)
//    @NumberFormat("#.##")
    private Double money;
}



